OpenEdge Reporting:<br />Report Builder Deployment Running a report with a simple filter override

The rbfilt1.p sample procedure runs the Customer Discount report in the rbsample.prl report library with the specified filter override:

rbfilt1.p
DO TRANSACTION: /* 1 / CREATE RBREPORT. / 2 / ASSIGN RBREPORT.RB-REPORT-LIBRARY = "c:\dlc\src\aderb\rbsample.prl" RBREPORT.RB-REPORT-NAME = "Customer Discount" RBREPORT.RB-PRINT-DESTINATION = "D" RBREPORT.RB-INCLUDE-RECORDS = "O" RBREPORT.RB-FILTER = "IN-RANGE(Order-Line.Discount, 15, 30)" RBREPORT.RB-DISPLAY-STATUS = yes RBREPORT.RB-DISPLAY-ERRORS = yes. / 3 / RELEASE RBREPORT. END. / 4 */ RUN aderb\_prore.p(false, "-db Runtable -S `servername` -H `hostname` -N `networktype` -rbdel").

  DO TRANSACTION:
 
/* 1 */ 
  CREATE RBREPORT.  

/* 2 */ 
  ASSIGN 
    RBREPORT.RB-REPORT-LIBRARY = "c:\dlc\src\aderb\rbsample.prl"
    RBREPORT.RB-REPORT-NAME = "Customer Discount"
    RBREPORT.RB-PRINT-DESTINATION = "D"
    RBREPORT.RB-INCLUDE-RECORDS = "O"    
    RBREPORT.RB-FILTER = "IN-RANGE(Order-Line.Discount, 15, 30)"
    RBREPORT.RB-DISPLAY-STATUS = yes
    RBREPORT.RB-DISPLAY-ERRORS = yes.
    
/* 3 */ 
  RELEASE RBREPORT.  

  END.

/* 4 */ 
  RUN aderb\_prore.p(false,
    "-db Runtable -S servername -H hostname -N networktype -rbdel").

Create the RBREPORT record.

Assign values to the record, including the filter override condition.

Explicitly release the RBREPORT record so that Report Engine can use it.

Call _prore to invoke Report Engine and run the report with the filter override. Then use the Report Delete (-rbdel) parameter to delete the record from the Report Engine table when the procedure is done.